CREATE TABLE [admin] (
	[adminusername] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[adminpassword] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [aaaaaadmin_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[adminusername]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [TD_CategoryTbl] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[CategoryName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EnglishDetails] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [aaaaaTD_CategoryTbl_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [TD_EvalSUsers] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[EvalEmail] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Site_ID] [int] NULL CONSTRAINT [DF__TD_EvalSU__Site___0425A276] DEFAULT (0),
	[EvalDate] [datetime] NULL ,
	CONSTRAINT [aaaaaTD_EvalSUsers_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [TD_SourcesTbl] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Category] [int] NULL CONSTRAINT [DF__TD_Source__Categ__76CBA758] DEFAULT (0),
	[Name] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[URL] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Desc] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[AuthEmail] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[SubmitDate] [datetime] NULL CONSTRAINT [DF__TD_Source__Submi__77BFCB91] DEFAULT (getdate()),
	[UpdateDate] [datetime] NULL CONSTRAINT [DF__TD_Source__Updat__78B3EFCA] DEFAULT (getdate()),
	[Approved] [bit] NOT NULL CONSTRAINT [DF__TD_Source__Appro__79A81403] DEFAULT (0),
	[totalhits] [int] NULL CONSTRAINT [DF__TD_Source__total__7A9C383C] DEFAULT (0),
	[VotesNumber] [int] NULL CONSTRAINT [DF__TD_Source__Votes__7B905C75] DEFAULT (0),
	[VotesValue] [int] NULL CONSTRAINT [DF__TD_Source__Votes__7C8480AE] DEFAULT (0),
	[EditPrev] [bit] NOT NULL CONSTRAINT [DF__TD_Source__EditP__7D78A4E7] DEFAULT (0),
	[Special] [bit] NOT NULL CONSTRAINT [DF__TD_Source__Speci__7E6CC920] DEFAULT (0),
	[BrokenLink] [bit] NOT NULL CONSTRAINT [DF__TD_Source__Broke__7F60ED59] DEFAULT (0),
	CONSTRAINT [aaaaaTD_SourcesTbl_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO